TG: sql_for_qa/70

SQL для тестировщика

Какой из следующих SQL запросов вернет топ-5 наиболее часто встречающихся значений из колонки с названием "cat" таблицы "products"?

Anonymous Quiz

SELECT TOP 5 cat, COUNT() AS count FROM products GROUP BY cat ORDER BY count DESC;

SELECT cat, COUNT() AS count FROM products GROUP BY cat ORDER BY count DESC LIMIT 5;

SELECT cat, COUNT() AS count FROM products GROUP BY cat ORDER BY count DESC FETCH NEXT 5 ROWS ONLY;

SELECT cat, COUNT() AS count FROM products GROUP BY cat ORDER BY count DESC WHERE ROWNUM <= 5;

585 answered

www.tg-me.com/in/SQL для тестировщика/com.sql_for_qa/70

2.6K viewsMar 26, 2023 at 07:05

tg-me.com/sql_for_qa/70

Create: 2023-03-26
Last Update: 2025-07-02 05:02:58

BY SQL для тестировщика

Warning: Undefined variable $i in /var/www/tg-me/post.php on line 283

Share with your friend now:
tg-me.com/sql_for_qa/70

SQL для тестировщика Telegram | DID YOU KNOW?

The S&P 500 slumped 1.8% on Monday and Tuesday, thanks to China Evergrande, the Chinese property company that looks like it is ready to default on its more-than $300 billion in debt. Cries of the next Lehman Brothers—or maybe the next Silverado?—echoed through the canyons of Wall Street as investors prepared for the worst.

The lead from Wall Street offers little clarity as the major averages opened lower on Friday and then bounced back and forth across the unchanged line, finally finishing mixed and little changed.The Dow added 33.18 points or 0.10 percent to finish at 34,798.00, while the NASDAQ eased 4.54 points or 0.03 percent to close at 15,047.70 and the S&P 500 rose 6.50 points or 0.15 percent to end at 4,455.48. For the week, the Dow rose 0.6 percent, the NASDAQ added 0.1 percent and the S&P gained 0.5 percent.The lackluster performance on Wall Street came on uncertainty about the outlook for the markets following recent volatility.